Report Query - Free Type
Create your report query manually using free type.
Query Tools
| Icon | Name | Description |
|---|---|---|
|
Refresh Fields | Refresh the tables in your query. This will run the query so Argos can determine the correct field names. |
|
Field Security | Set Column Level Security on your query. Allow or deny certain users or groups access to specific columns of a table. |
|
Visual Design | If you decide you would like to create your query in the Visual Designer instead, click this button. Note: Free Type does not carry over to the Visual Designer. |
|
Insert Special | If you are using the Filter tab or Sort tab on a Banded Report, a special character is required to let Argos know where the additional filter or sort will go in the query. |
| Type | Gives the data type of a selected field. | |
|
Insert Variable | Add system variables or parameters to your query. |
| Operators | Add logical operators to your query. | |
| Edit query properties | Modify data connection settings. It is recommended that these settings are left set as their defaults unless otherwise instructed by an Evisions support technician. | |
| Keyboard shortcuts | You can use Ctrl-F to find text or Ctrl-H to find/replace text within the free type query. |
- If you need additional help creating DataBlocks, refer to the Getting Started with DataBlocks page.
- Also refer to Example 9 (Free Type Report Query) in the Argos DataBlock Designers Guide.